package com.hsoft.zhxy.common.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hsoft.zhxy.common.system.model.SystemBO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Set;

@Mapper
@Repository
public interface SystemMapper extends BaseMapper<SystemBO> {

    @Select("select qqlj from jcqx_yh yh left join jcqx_yhjs yhjs on yh.yhid = yhjs.yhid "  +
            "left join jcqx_jszy jszy on yhjs.jsid = jszy.jsid " +
            "left join jcqx_gnzy gnzy on  jszy.gnzyid = gnzy.gnzyid where yh.yhid = #{yhid}")
    List<String> findQqljList(String yhid);

    @Select("select qqlj from jcqx_gnzy")
    List<String> findQqljListGnzy();

    @Select("select sfpdqx from jcqx_gnzy where qqlj = #{qqlj}")
    Integer getSfpdqx(String qqlj);

    @Select("select xm from jcqx_yh where yhid = #{yhid}")
    String getYhxx(String yhid);
}
